﻿CREATE TABLE [dbo].[User] (
    [Id]            BIGINT         IDENTITY (1, 1) NOT NULL,
    [FirstName]     NVARCHAR (100) NULL,
    [LastName]      NVARCHAR (100) NULL,
    [ShortName]     NVARCHAR (12)  NULL,
    [Username]      NVARCHAR (100) NULL,
    [Password]      NVARCHAR (50)  NULL,
    [Role]          INT            NULL,
    [IsActive]      BIT            NULL,
    [DataContextId] BIGINT         NULL,
    [ChangeDate]    DATETIME       NULL,
    [CreateDate]    DATETIME       NULL,
    [ChangedById]   BIGINT         NULL,
    [CreatedById]   BIGINT         NULL
);

